Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderMediaBrandID (PK) | Token identifier for a tender media brand. | ID_TND_MD_BRN | Identity | integer | |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | Tender(AS_TND) |
CoBrandName | The trade name used to differentiate the tender media for a specific sponsor from other generic or sponsored tender media that belongs to the same tender type. For example: TenderType: CreditCard-VISA (from account) CoBrandName: CaptialOne or GIANT VIsa (co branded for a retailer. | NM_CO_BRN | DescriptionShort | varchar(255) | |
TenderMediaCoSponsorID (FK) | Token identifier for an organization that sponsors a particular brand of tender media. Examples include Marriott VISA credit card, US AIR Master card, etc. | ID_TND_MD_COSPNSR | Identity | integer | TenderMediaCoSponsor(PA_TND_MD_COSPNSR) |